{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Scorecard","Controls","Definitions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Scorecard with risk shown"]
[]
[null,"The best way to manage risk is within core management activities, such as business planning, monitoring, and design."]
[]
[null,"This spreadsheet is for showing performance on performance indicators, including forecasts for the future that make it easier to do monitoring."]
[]
[null,"The forecasts include probabilities of two levels of poor performance, one just 'disappointing' or worse, and the other for a 'serious problem'. "]
[]
[null,"In a business monitoring meeting it is best to consider what might happen to results under different circumstances, not just the best guess."]
[]
[null,"In the event of an audit or similar review by someone looking for a risk register, the possibilities of disappointing or problematic performance may be offered as the 'risks' in a risk register, while the mapping of performance indicators to 'controls' (or other types of action) provides the risk-control mapping the reviewer is probably also looking for."]
[]
[null,"The same type of spreadsheet used at a lower organizational level can show the drivers of top level performance indicators broken down into more detail, if that is required."]
[]
[null,"Several columns are provided for capturing information about controls and you can use, ignore, or add to them as you wish."]
[]
[null,"One special feature of this design is that a macro (on the button) bring the performance indicators used as headings in the Controls sheet into line with the Scorecard."]
[]
[null,"This is done by working from the Scorecard to the Controls matrix, preserving control mapping information only where the performance indicator reference in the Scorecard matches a performance indicator reference in the control matrix."]
[]
[null,"Whenever you change the Scorecard use the button at the end to bring the two back into agreement."]
[]
[null,"For more information"]
[]
[null,"This template was devised by Matthew Leitch and more information may be found on his website at http://www.workinginuncertainty.co.uk/downloads%20scorecard%20with%20risk.shtml."]
[]
[null,"Please feel free to contact me with any queries or suggestions at matthew@workinginuncertainty.co.uk"]

{"sheet":"Scorecard","index":1,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[4,2,4,6],[4,9,4,11],[4,12,4,14]]}
[null,null,"Scorecard"]
[]
["field names","ref","category","level","short name","definition","accountable",null,null,"current estimate","current p dis","current p prob","proposed estimate","proposed p dis","proposed p prob",null,null,"END"]
[]
[null,null,"Indicator",null,null,null,null,"Actual results",null,"Forecast results with existing plans (including controls)",null,null,"Forecast results with proposed changes"]
[null,"Ref","Category","Level","Performance indicator short name","Performance indicator definition","Accountable for indicator","Last month","12m rolling average","Best estimate for 3m ahead","Probability of disappoint-ment","Probability of serious problem","Best estimate for 3m ahead","Probability of disappoint-ment","Probability of serious problem"]
["pi 1","f1","Financial","Top","financial 1","defin 1",null,null,null,{"$f":"Controls!$R$16","v":1},{"$f":"Controls!$R$17","v":0.5},{"$f":"Controls!$R$18","v":0.2},{"$f":"Controls!$R$30","v":1},{"$f":"Controls!$R$31","v":0.4},{"$f":"Controls!$R$32","v":0.1}]
[null,"f2","Financial","Top","financial 2","defin 2",null,null,null,{"$f":"Controls!$S$16","v":1},{"$f":"Controls!$S$17","v":0.3},{"$f":"Controls!$S$18","v":0.1},{"$f":"Controls!$S$30","v":1},{"$f":"Controls!$S$31","v":0.2},{"$f":"Controls!$S$32","v":0.03}]
[null,"f3","Financial","Top","financial 3","defin 3",null,null,null,{"$f":"Controls!$T$16","v":1},{"$f":"Controls!$T$17","v":0.1},{"$f":"Controls!$T$18","v":0.05},{"$f":"Controls!$T$30","v":1},{"$f":"Controls!$T$31","v":0.1},{"$f":"Controls!$T$32","v":0.04}]
[null,"p1","People","Top","people 1","defin 4",null,null,null,{"$f":"Controls!$U$16","v":1},{"$f":"Controls!$U$17","v":0.8},{"$f":"Controls!$U$18","v":0.3},{"$f":"Controls!$U$30","v":1},{"$f":"Controls!$U$31","v":0.4},{"$f":"Controls!$U$32","v":0.2}]
[null,"p2","People","Top","people 2","defin 5",null,null,null,{"$f":"Controls!$V$16","v":1},{"$f":"Controls!$V$17","v":0.3},{"$f":"Controls!$V$18","v":0.05},{"$f":"Controls!$V$30","v":1},{"$f":"Controls!$V$31","v":0.4},{"$f":"Controls!$V$32","v":0.2}]
[null,"c1","Customer","Top","Customer 1","Defn 6",null,null,null,{"$f":"Controls!$W$16","v":0},{"$f":"Controls!$W$17","v":0},{"$f":"Controls!$W$18","v":0},{"$f":"Controls!$W$30","v":0},{"$f":"Controls!$W$31","v":0},{"$f":"Controls!$W$32","v":0}]
[]
[]
[]
["END"]

{"sheet":"Controls","index":2,"n_rows":94,"n_cols":25,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[null,null,"Actions (including controls)"]
[]
["field names","sort","group","control",null,null,"control id",null,null,null,null,null,null,null,null,null,"start",null,null,null,null,null,null,null,"END"]
[]
[]
["pi ref",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KPI ref","f1","f2","f3","p1","p2","c1"]
["col heads","Sort","Control group","Control","Status / Action","To do date","Control ID","Ref to detail","Owner - development","Development cost","Owner - operational","Frequency","Sampling","Operation cost","Performance evidence","Perform-ance rating","Short name","financial 1","financial 2","financial 3","people 1","people 2","Customer 1"]
[]
[null,null,"ACTIONS/CONTROLS CURRENTLY IN PLACE AND UNDER DEVELOPMENT"]
["current 1",1,"Monitoring","Business monitoring report: debtors","In place",null,"m1"]
[null,2,"Monitoring","Process monitoring report: process stats","In place",null,"m2"]
[null,"etc","etc","etc"]
[]
[]
["count",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count",{"$f":"SUM(R10:R14)","v":0},{"$f":"SUM(S10:S14)","v":0},0,0,0,{"$f":"SUM(W10:W14)","v":0}]
["current estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Best estimate for 3m ahead",1,1,1,1,1]
["current p dis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probability of disappointment",0.5,0.3,0.1,0.8,0.3]
["current p prob",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probability of serious problem",0.2,0.1,0.05,0.3,0.05]
[]
[]
[null,null,"CHANGES PROPOSED"]
["proposed 1",1,"Monitoring","Business monitoring report: debtors","Add","2015-08-01","m1"]
[null,2,"Monitoring","Process monitoring report: process stats","Remove",null,"m2"]
[null,"etc","etc","etc"]
[]
[]
[]
[]
["ecount",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Extended count",{"$f":"R15 + SUM(R22:R28)","v":0},{"$f":"S15 + SUM(S22:S28)","v":0},0,0,0,{"$f":"W15 + SUM(W22:W28)","v":0}]
["proposed estimate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Best estimate for 3m ahead",1,1,1,1,1]
["proposed p dis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probability of disappointment",0.4,0.2,0.1,0.4,0.4]
["proposed p prob",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probability of serious problem",0.1,0.03,0.04,0.2,0.2]
[]
[]
[]
["END"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"xxxx"]

{"sheet":"Definitions","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"PI",null,"Definition of 'disappointment'","Definition of 'serious problem'"]
[]
[null,"Financials"]
[null,"All financials",null,"Worse than current budget","at least 10% worse than current budget"]
[]
[null,"Non- financials"]
[null,"Safety",null,"Any incidents","One or more deaths"]
[null,"Customer experience",null,"Score below target","Score 3 points below target or worse"]
[null,"etc"]